Statement Analytics

Column Heading	Unique?	Type	Length	Details
Statement Number	Yes	Numeric	8	The CMP ID number for the statement
Group Code		Alphanumeric	6	The CMP code for the group associated with the statement
Corporate Code		Alphanumeric	6	The CMP code the corporate associated with the statement
Statement Date		Numeric	10	The date on the statement in DD/MM/YYYY format
Account Number		Numeric	8	The CMP account number associated with the statement
Total Statement Invoices		Numeric	8	The total of invoices associated with the statement
Total Debits This Statement		Numeric	11,2	The monetary total of all debits in the statement, to two decimal places
Total Credits This Statement		Numeric	11,2	The monetary total of all credits in the statement, to two decimal places
Total Transactions This Statement		Numeric	11,2	The total number of transactions in the statement
Opening Balance		Numeric	11,2	The opening monetary balance of the statement, to two decimal places
Closing Balance		Numeric	11,2	The closing monetary balance of the statement, to two decimal places
Previous Closing Balance		Numeric	11,2	The closing balance for the statement before this one for the customer, to two decimal places
Date Created		Numeric	7,0	The date the extract was created. YYYY-MM-DD format
Created By		Alphanumeric	10	User ID of user who created the record
Date Changed		Numeric	7,0	The date the extract was last changed. YYYY-MM-DD format
Changed By		Alphanumeric	10	User ID of user who last changed the record
Data Extract Date		Numeric	7,0	Date that the data above was extracted from CMP. YYYY-MM-DD format